<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateStudentsInfoTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('students_info', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('student_id')->nullable()->commnet('学生表关联');
            $table->string('xm')->nullable()->comment('姓名');
            $table->string('xh')->nullable()->comment('学号');
            $table->string('xbm')->nullable()->comment('性别');
            $table->string('csrq')->nullable()->comment('出生日期');
            $table->string('sfzjh')->nullable()->comment('身份证号');
            $table->string('mzm')->nullable()->comment('民族');
            $table->string('zzmmm')->nullable()->comment('政治面貌');
            $table->string('ywb')->nullable()->comment('班级');
            $table->string('lxdh')->nullable()->comment('联系方式');
            $table->string('zyfx')->nullable()->comment('专业');
            $table->string('xsh')->nullable()->commnet('学籍校');
            $table->string('nj')->nullable()->commnet('年级');
            $table->string('school')->nullable()->commnet('学院');
            $table->string('type')->nullable()->commnet('学制类型');
            $table->integer('status')->default(1)->nullable('信息状态 1未认证 2认证成功 3 修正');
            $table->text('update_desc')->nullable()->comment('更新信息');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('students_info');
    }
}
